1. To celebrate academic achievements, the examination board wants to identify the highest score in Test3 across all students and subjects. Write a SQL query to find the highest Test3 score as Highest_Test3_Score.
SELECT MAX(Test3) AS Highest_Test3_Score FROM Marks
2. The career services office wants to review and negotiate better packages by identifying the lowest salary package offered to placed students. Write a SQL query to find the lowest salary package as Lowest_Salary_Package.
SELECT MIN(Package) AS Lowest_Salary_Package FROM Students
3. The placement cell is analyzing company performance and wants to know the average number of students placed by all companies. Write a query to retrieve the average number of students placed as 'Average_Students_Placed'.
SELECT AVG(Students_placed) AS Average_Students_Placed FROM Companies
4. The dean's office is considering adding new branches of study and needs to know the current number of academic branches available. Write a SQL query to select the total number of branches as Total_Branches.
SELECT COUNT(Branch_name) AS Total_Branches FROM Branches
5. The placement cell is recognizing company performance and wants to know which company placed the most students. Write a Query to find the highest number of students placed as 'Most_Students_Placed'.
SELECT MAX(Students_placed) AS Most_Students_Placed FROM Companies
6. The HR department needs to know the number of unique designations among lecturers to plan for diverse training programs. Write a SQL query to select the count of unique designations as Unique_Designations.
SELECT COUNT(DISTINCT Designation) AS Unique_Designations FROM Lecturers
7. The career services office wants to determine how many unique companies have recruited students for campus placements. Write a SQL query to display the count of Unique Company ID as Unique_Recruiting_Companies
SELECT COUNT(DISTINCT CID) AS Unique_Recruiting_Companies FROM Students
8. The university administration is in the process of allocating a budget for faculty development programs. Write an SQL query to find the total count of lecturers and display the result as 'Total_Lecturers'.
SELECT COUNT(*) AS Total_Lecturers FROM Lecturers
9. The registrar's office needs to find out the latest graduation date among students for alumni outreach programs. Write an SQL query to find the latest graduation date as Latest_Graduation_Date.
SELECT MAX(DOG) AS Latest_Graduation_Date FROM Students
10. The examination department needs to identify the lowest score in Test1 across all subjects to address potential issues in student comprehension or exam difficulty. Write a SQL query to find the lowest Test1 score as Lowest_Test1_Score.
SELECT MIN(Test1) AS Lowest_Test1_Score FROM Marks
11. The university administration is planning to add new subjects to all semesters and needs to know the current total number of existing subjects. Write a SQL query to calculate the total number of subjects and display the result as 'Total_Subjects'.
SELECT COUNT(*) AS Total_Subjects FROM Subjects
12. The career services office wants to determine the average salary package offered to placed students to analyze the effectiveness of their placement program. Write a SQL query to determine the average salary package as Average_Salary_Package.
SELECT AVG(Package) AS Average_Salary_Package FROM Students
13. The career services office needs to know the number of distinct job roles students have been placed in to tailor career counseling services. Write a SQL query to select the count of unique job roles as Unique_Job_Roles.
SELECT COUNT(DISTINCT Job_role) AS Unique_Job_Roles FROM Students
14. To assess student performance in the third test across all subjects, the examination board wants to find the average Test3 score. Write a SQL query to calculate the average Test3 score as Average_Test3_Score.
SELECT AVG(Test3) AS Average_Test3_Score FROM Marks
15. The HR department is analyzing employee tenure and wants to find the earliest date any student joined a company post-graduation. Write a SQL query to find the earliest joining date as Earliest_Joining_Date.
SELECT MIN(DOJ) AS Earliest_Joining_Date FROM Students